AdConcentration 
Logical Entity Name  AdConcentration 
Default Table Name  AdConcentration 
Physical Only  NO 
Definition 
 
Note 
 

AdConcentration Columns 
ColumnName  Domain  Datatype  NULL  Definition 
AdConcentrationID(PK)    int  NO 
 
Code    varchar(8)  NO 
 
Descrip    varchar(120)  NO 
 
SyCampusGrpID(FK)    int  NO 
 
Active    bit  NO 
 
UserID(FK)    int  NO 
 
DateAdded    datetime  NO 
 
DateLstMod    datetime  NO 
 
ts    timestamp  NO 
 
MinGPA    numeric(11, 6)  YES 
 
CreditsReq    numeric(9, 2)  YES 
 
AdConcentrationTypeID(FK)    int  NO 
 
CIPCode(FK)    varchar(7)  YES 
 
CrmSuppressFlag    bit  NO 
 
CurrentAdCIPCodeYearId(FK)    char(10)  YES 
 
overallApprovedTransferCredit    char(10)  NO 
 
TotalApprovedTransferCredit    char(10)  YES 
 

AdConcentration Primary and Unique Keys 
Key Name  Key Type  Keys 
AdConcentration_SyCampusGrpID_U_N_IDX  Index  SyCampusGrpID 
AdConcentration_AdConcentrationID_U_C_IDX  PrimaryKey  AdConcentrationID 
AdConcentration_Code_U_N_IDX  Index  Code 

AdConcentration Foreign Keys 
Parent Relationships: 
Table Name  Type  Cardinality  Constraint Name  VerbPhrase  InversePhrase  Foreign Keys  Is Supertype  Not For Replication 
AdConcentrationType  Non-Identifying  One To Zero or More  FK_AdConcentration.AdConcentrationTypeID_AdConcentrationType.AdConcentrationTypeID      AdConcentrationTypeID  NO  YES 
adCIPCode  Non-Identifying  Zero or One to Zero or More  FK_AdConcentration_CIPCode_adCIPCode_CIPCode      CIPCode  NO  YES 
AdCIPCodeYear  Non-Identifying  Zero or One to Zero or More  FK_AdConcentration_CurrentAdCIPCodeYearId_AdCIPCodeYear_AdCIPCodeYearId      CurrentAdCIPCodeYearId  NO  YES 
SyCampusGrp  Non-Identifying  One To Zero or More  FK_AdConcentration_SyCampusGrpID_SyCampusGrp_SyCampusGrpID      SyCampusGrpID  NO  YES 
SyStaff  Non-Identifying  One To Zero or More  FK_AdConcentration_UserID_SyStaff_SyStaffID      UserID  NO  YES 
Child Relationships: 
Table Name  Type  Cardinality  Constraint Name  VerbPhrase  InversePhrase  Foreign Keys  Is Subtype  Not For Replication 
AdApprovedTransferCreditRestrictions  Non-Identifying  One To Zero or More  FK_AdApprovedTransferCreditRestrictions_AdConcentrationID_AdConcentration_AdConcentrationID        NO  YES 
AdCipCodeReporting  Non-Identifying  One To Zero or More  FK_AdCipCodeReporting_AdConcentrationId_AdConcentration_AdConcentrationID        NO  YES 
AdConcentrationByProgramVersion  Non-Identifying  One To Zero or More  FK_AdConcentrationByProgramVersion_AdConcentrationID_AdConcentration_AdConcentrationID        NO  YES 
adConcentrationExternalMap  Non-Identifying  One To Zero or More  FK_adConcentrationExternalMapadConcentrationId_adConcentrationadConcentrationId        NO  YES 
AdConcentrationRequirementRule  Identifying  One To Zero or More  FK_AdConcentrationRequirementRule_AdConcentrationID_AdConcentration_AdConcentrationID        NO  YES 
AdDegreePathwayTemplate  Non-Identifying  One To Zero or More  FK_AdDegreePathwayTemplate_AdConcentrationId_AdConcentration_AdConcentrationID        NO  YES 
AdEnrollDegreeAuditCourseCategory  Non-Identifying  One To Zero or More  FK_AdEnrollDegreeAuditCourseCategory_AdConcentrationID_AdConcentration_AdConcentrationID        NO  YES 
AdEnrollDegreeAuditRequirementRule  Non-Identifying  One To Zero or More  FK_AdEnrollDegreeAuditRequirementRule_AdConcentrationID_AdConcentration_AdConcentrationID        NO  YES 
AdMajorConcentration  Non-Identifying  One To Zero or More  FK_AdMajorConcentration.AdConcentrationID_AdConcentration.AdConcentrationID        NO  YES 
AdMajorConcentration  Non-Identifying  One To Zero or More  FK_AdMajorConcentration.AdMajorID_AdConcentration.AdConcentrationID        NO  YES 
AdProgramCourse  Non-Identifying  One To Zero or More  FK_AdProgramCourse.AdConcentrationID_AdConcentration.AdConcentrationID        NO  YES 
AdProgramCourseCategory  Non-Identifying  One To Zero or More  FK_AdProgramCourseCategory.AdConcentrationID_AdConcentration.AdConcentrationID        NO  YES 
AdStudentDegreePathway  Non-Identifying  One To Zero or More  FK_AdStudentDegreePathway_AdConcentrationId_AdConcentration_AdConcentrationID        NO  YES 
AmOnlineApplicantConcentration  Non-Identifying  One To Zero or More  FK_AmOnlineApplicantConcentration_AdConcentrationID_AdConcentration_AdConcentrationID        NO  YES 
FaProgramVersionCOA  Non-Identifying  One To Zero or More  FK_FaProgramVersionCOA_AdConcentrationId_AdConcentration_AdConcentrationId        NO  YES 

AdConcentration Check Constraints 
Check Constraint Name  CheckConstraint